﻿CREATE TABLE [dbo].[Stays] (
    [StayId]        INT             IDENTITY (1, 1) NOT NULL,
    [RoomId]        INT             NOT NULL,
    [StartDate]     DATETIME        NOT NULL,
    [EndDate]       DATETIME        NOT NULL,
    [Notes]         NVARCHAR (1000) NULL,
    [ServiceTypeId] INT             NOT NULL
);



